﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PanamaDataSet" targetNamespace="http://tempuri.org/PanamaDataSet.xsd" xmlns:mstns="http://tempuri.org/PanamaDataSet.xsd" xmlns="http://tempuri.org/PanamaDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="PanamaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PanamaConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.PanamaConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PcodesTableAdapter" GeneratorDataComponentClassName="PcodesTableAdapter" Name="Pcodes" UserDataComponentName="PcodesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PanamaConnectionString (Web.config)" DbObjectName="Panama.dbo.Pcodes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pcodes] WHERE (([PCode] = @Original_PCode))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pcodes] ([PCode], [Anal_Name], [Units], [Test_Method], [Det_Limit], [Sig_Figs], [Min_Limit], [Max_Limit], [Min_Criteria], [Max_Criteria], [Format_Str], [Convert_PCode], [Convert_Units], [Convert_Mult], [WQX_CharacteristicName], [WQX_ResultSampFraction], [WQX_ResultMeasureUnit], [WQX_AnalyticalMethodIDContext], [WQX_AnalyticalMethodID], [WQX_AnalyticalMethodName], [WQX_AnalyticalMethodQualifType], [WQX_AnalyticalMethodDesc], [Create_Update]) VALUES (@PCode, @Anal_Name, @Units, @Test_Method, @Det_Limit, @Sig_Figs, @Min_Limit, @Max_Limit, @Min_Criteria, @Max_Criteria, @Format_Str, @Convert_PCode, @Convert_Units, @Convert_Mult, @WQX_CharacteristicName, @WQX_ResultSampFraction, @WQX_ResultMeasureUnit, @WQX_AnalyticalMethodIDContext, @WQX_AnalyticalMethodID, @WQX_AnalyticalMethodName, @WQX_AnalyticalMethodQualifType, @WQX_AnalyticalMethodDesc, @Create_Update)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Anal_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Anal_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Units" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Units" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Test_Method" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Test_Method" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Det_Limit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Det_Limit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Sig_Figs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Sig_Figs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Min_Limit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Min_Limit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Max_Limit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Max_Limit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Min_Criteria" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Min_Criteria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Max_Criteria" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Max_Criteria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Format_Str" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Format_Str" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Convert_PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Convert_PCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Convert_Units" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Convert_Units" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Convert_Mult" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Convert_Mult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_CharacteristicName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_CharacteristicName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_ResultSampFraction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_ResultSampFraction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_ResultMeasureUnit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_ResultMeasureUnit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodIDContext" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodIDContext" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodQualifType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodQualifType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Update" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Update" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PCode, Anal_Name, Units, Test_Method, Det_Limit, Sig_Figs, Min_Limit, Max_Limit, Min_Criteria, Max_Criteria, Format_Str, Convert_PCode, Convert_Units, Convert_Mult, WQX_CharacteristicName, WQX_ResultSampFraction, WQX_ResultMeasureUnit, WQX_AnalyticalMethodIDContext, WQX_AnalyticalMethodID, WQX_AnalyticalMethodName, WQX_AnalyticalMethodQualifType, WQX_AnalyticalMethodDesc, Create_Update FROM dbo.Pcodes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pcodes] SET [PCode] = @PCode, [Anal_Name] = @Anal_Name, [Units] = @Units, [Test_Method] = @Test_Method, [Det_Limit] = @Det_Limit, [Sig_Figs] = @Sig_Figs, [Min_Limit] = @Min_Limit, [Max_Limit] = @Max_Limit, [Min_Criteria] = @Min_Criteria, [Max_Criteria] = @Max_Criteria, [Format_Str] = @Format_Str, [Convert_PCode] = @Convert_PCode, [Convert_Units] = @Convert_Units, [Convert_Mult] = @Convert_Mult, [WQX_CharacteristicName] = @WQX_CharacteristicName, [WQX_ResultSampFraction] = @WQX_ResultSampFraction, [WQX_ResultMeasureUnit] = @WQX_ResultMeasureUnit, [WQX_AnalyticalMethodIDContext] = @WQX_AnalyticalMethodIDContext, [WQX_AnalyticalMethodID] = @WQX_AnalyticalMethodID, [WQX_AnalyticalMethodName] = @WQX_AnalyticalMethodName, [WQX_AnalyticalMethodQualifType] = @WQX_AnalyticalMethodQualifType, [WQX_AnalyticalMethodDesc] = @WQX_AnalyticalMethodDesc, [Create_Update] = @Create_Update WHERE (([PCode] = @Original_PCode))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Anal_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Anal_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Units" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Units" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Test_Method" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Test_Method" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Det_Limit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Det_Limit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Sig_Figs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Sig_Figs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Min_Limit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Min_Limit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Max_Limit" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Max_Limit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Min_Criteria" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Min_Criteria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Max_Criteria" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Max_Criteria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Format_Str" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Format_Str" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Convert_PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Convert_PCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Convert_Units" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Convert_Units" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Convert_Mult" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Convert_Mult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_CharacteristicName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_CharacteristicName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_ResultSampFraction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_ResultSampFraction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_ResultMeasureUnit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_ResultMeasureUnit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodIDContext" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodIDContext" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodQualifType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodQualifType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WQX_AnalyticalMethodDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WQX_AnalyticalMethodDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Update" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Update" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PCode" DataSetColumn="PCode" />
              <Mapping SourceColumn="Anal_Name" DataSetColumn="Anal_Name" />
              <Mapping SourceColumn="Units" DataSetColumn="Units" />
              <Mapping SourceColumn="Test_Method" DataSetColumn="Test_Method" />
              <Mapping SourceColumn="Det_Limit" DataSetColumn="Det_Limit" />
              <Mapping SourceColumn="Sig_Figs" DataSetColumn="Sig_Figs" />
              <Mapping SourceColumn="Min_Limit" DataSetColumn="Min_Limit" />
              <Mapping SourceColumn="Max_Limit" DataSetColumn="Max_Limit" />
              <Mapping SourceColumn="Min_Criteria" DataSetColumn="Min_Criteria" />
              <Mapping SourceColumn="Max_Criteria" DataSetColumn="Max_Criteria" />
              <Mapping SourceColumn="Format_Str" DataSetColumn="Format_Str" />
              <Mapping SourceColumn="Convert_PCode" DataSetColumn="Convert_PCode" />
              <Mapping SourceColumn="Convert_Units" DataSetColumn="Convert_Units" />
              <Mapping SourceColumn="Convert_Mult" DataSetColumn="Convert_Mult" />
              <Mapping SourceColumn="WQX_CharacteristicName" DataSetColumn="WQX_CharacteristicName" />
              <Mapping SourceColumn="WQX_ResultSampFraction" DataSetColumn="WQX_ResultSampFraction" />
              <Mapping SourceColumn="WQX_ResultMeasureUnit" DataSetColumn="WQX_ResultMeasureUnit" />
              <Mapping SourceColumn="WQX_AnalyticalMethodIDContext" DataSetColumn="WQX_AnalyticalMethodIDContext" />
              <Mapping SourceColumn="WQX_AnalyticalMethodID" DataSetColumn="WQX_AnalyticalMethodID" />
              <Mapping SourceColumn="WQX_AnalyticalMethodName" DataSetColumn="WQX_AnalyticalMethodName" />
              <Mapping SourceColumn="WQX_AnalyticalMethodQualifType" DataSetColumn="WQX_AnalyticalMethodQualifType" />
              <Mapping SourceColumn="WQX_AnalyticalMethodDesc" DataSetColumn="WQX_AnalyticalMethodDesc" />
              <Mapping SourceColumn="Create_Update" DataSetColumn="Create_Update" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Pvsca_MtrTableAdapter" GeneratorDataComponentClassName="Pvsca_MtrTableAdapter" Name="Pvsca_Mtr" UserDataComponentName="Pvsca_MtrTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PanamaConnectionString (Web.config)" DbObjectName="Panama.dbo.Pvsca_Mtr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pvsca_Mtr] WHERE (([RecID] = @Original_RecID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pvsca_Mtr] ([RecID], [Station_ID], [Date_Time], [PCode], [LEW_Pct], [Depth_M], [Agency], [CCode], [LCode], [SCode], [QCode], [RCode], [Result], [Validated], [Create_Update], [Owner], [Track_ID]) VALUES (@RecID, @Station_ID, @Date_Time, @PCode, @LEW_Pct, @Depth_M, @Agency, @CCode, @LCode, @SCode, @QCode, @RCode, @Result, @Validated, @Create_Update, @Owner, @Track_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date_Time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date_Time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@LEW_Pct" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="LEW_Pct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Depth_M" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Depth_M" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Agency" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agency" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@QCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="QCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Result" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Validated" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Validated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Update" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Update" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Owner" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Owner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Track_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Track_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RecID, Station_ID, Date_Time, PCode, LEW_Pct, Depth_M, Agency, CCode, LCode, SCode, QCode, RCode, Result, Validated, Create_Update, Owner, Track_ID FROM dbo.Pvsca_Mtr</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pvsca_Mtr] SET [RecID] = @RecID, [Station_ID] = @Station_ID, [Date_Time] = @Date_Time, [PCode] = @PCode, [LEW_Pct] = @LEW_Pct, [Depth_M] = @Depth_M, [Agency] = @Agency, [CCode] = @CCode, [LCode] = @LCode, [SCode] = @SCode, [QCode] = @QCode, [RCode] = @RCode, [Result] = @Result, [Validated] = @Validated, [Create_Update] = @Create_Update, [Owner] = @Owner, [Track_ID] = @Track_ID WHERE (([RecID] = @Original_RecID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date_Time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date_Time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@LEW_Pct" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="LEW_Pct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Depth_M" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Depth_M" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Agency" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agency" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@QCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="QCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Result" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Validated" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Validated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Update" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Update" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Owner" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Owner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Track_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Track_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RecID" DataSetColumn="RecID" />
              <Mapping SourceColumn="Station_ID" DataSetColumn="Station_ID" />
              <Mapping SourceColumn="Date_Time" DataSetColumn="Date_Time" />
              <Mapping SourceColumn="PCode" DataSetColumn="PCode" />
              <Mapping SourceColumn="LEW_Pct" DataSetColumn="LEW_Pct" />
              <Mapping SourceColumn="Depth_M" DataSetColumn="Depth_M" />
              <Mapping SourceColumn="Agency" DataSetColumn="Agency" />
              <Mapping SourceColumn="CCode" DataSetColumn="CCode" />
              <Mapping SourceColumn="LCode" DataSetColumn="LCode" />
              <Mapping SourceColumn="SCode" DataSetColumn="SCode" />
              <Mapping SourceColumn="QCode" DataSetColumn="QCode" />
              <Mapping SourceColumn="RCode" DataSetColumn="RCode" />
              <Mapping SourceColumn="Result" DataSetColumn="Result" />
              <Mapping SourceColumn="Validated" DataSetColumn="Validated" />
              <Mapping SourceColumn="Create_Update" DataSetColumn="Create_Update" />
              <Mapping SourceColumn="Owner" DataSetColumn="Owner" />
              <Mapping SourceColumn="Track_ID" DataSetColumn="Track_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StationsTableAdapter" GeneratorDataComponentClassName="StationsTableAdapter" Name="Stations" UserDataComponentName="StationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PanamaConnectionString (Web.config)" DbObjectName="Panama.dbo.Stations" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Stations] WHERE (([Station_ID] = @Original_Station_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Stations] ([Station_ID], [Station_Name], [Station_Type], [Data_Freq], [Latitude], [Longitude], [Elevation], [HUC], [Branch_ID], [River_Mile], [Reach_ID], [Dr_Area], [Agency], [Ref_ID], [Remarks], [Other], [WaterBodyType], [Basin_Name], [State], [County_Name], [FIPS_Code], [EcoRegion], [PlanRegion], [Convert_Station_ID], [Create_Update]) VALUES (@Station_ID, @Station_Name, @Station_Type, @Data_Freq, @Latitude, @Longitude, @Elevation, @HUC, @Branch_ID, @River_Mile, @Reach_ID, @Dr_Area, @Agency, @Ref_ID, @Remarks, @Other, @WaterBodyType, @Basin_Name, @State, @County_Name, @FIPS_Code, @EcoRegion, @PlanRegion, @Convert_Station_ID, @Create_Update)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Data_Freq" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Data_Freq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Latitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Longitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Elevation" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HUC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HUC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Branch_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Branch_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@River_Mile" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="River_Mile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reach_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reach_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Dr_Area" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Dr_Area" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Agency" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agency" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Other" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Other" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WaterBodyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WaterBodyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Basin_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Basin_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@County_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="County_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FIPS_Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIPS_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EcoRegion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EcoRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PlanRegion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PlanRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Convert_Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Convert_Station_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Update" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Update" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Station_ID, Station_Name, Station_Type, Data_Freq, Latitude, Longitude, Elevation, HUC, Branch_ID, River_Mile, Reach_ID, Dr_Area, Agency, Ref_ID, Remarks, Other, WaterBodyType, Basin_Name, State, County_Name, FIPS_Code, EcoRegion, PlanRegion, Convert_Station_ID, Create_Update FROM dbo.Stations</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Stations] SET [Station_ID] = @Station_ID, [Station_Name] = @Station_Name, [Station_Type] = @Station_Type, [Data_Freq] = @Data_Freq, [Latitude] = @Latitude, [Longitude] = @Longitude, [Elevation] = @Elevation, [HUC] = @HUC, [Branch_ID] = @Branch_ID, [River_Mile] = @River_Mile, [Reach_ID] = @Reach_ID, [Dr_Area] = @Dr_Area, [Agency] = @Agency, [Ref_ID] = @Ref_ID, [Remarks] = @Remarks, [Other] = @Other, [WaterBodyType] = @WaterBodyType, [Basin_Name] = @Basin_Name, [State] = @State, [County_Name] = @County_Name, [FIPS_Code] = @FIPS_Code, [EcoRegion] = @EcoRegion, [PlanRegion] = @PlanRegion, [Convert_Station_ID] = @Convert_Station_ID, [Create_Update] = @Create_Update WHERE (([Station_ID] = @Original_Station_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Station_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Data_Freq" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Data_Freq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Latitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Longitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Elevation" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HUC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HUC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Branch_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Branch_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@River_Mile" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="River_Mile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reach_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reach_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Dr_Area" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Dr_Area" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Agency" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agency" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Other" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Other" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WaterBodyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WaterBodyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Basin_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Basin_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@County_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="County_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FIPS_Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIPS_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EcoRegion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EcoRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PlanRegion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PlanRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Convert_Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Convert_Station_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Update" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Update" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Station_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Station_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Station_ID" DataSetColumn="Station_ID" />
              <Mapping SourceColumn="Station_Name" DataSetColumn="Station_Name" />
              <Mapping SourceColumn="Station_Type" DataSetColumn="Station_Type" />
              <Mapping SourceColumn="Data_Freq" DataSetColumn="Data_Freq" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longitude" DataSetColumn="Longitude" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
              <Mapping SourceColumn="HUC" DataSetColumn="HUC" />
              <Mapping SourceColumn="Branch_ID" DataSetColumn="Branch_ID" />
              <Mapping SourceColumn="River_Mile" DataSetColumn="River_Mile" />
              <Mapping SourceColumn="Reach_ID" DataSetColumn="Reach_ID" />
              <Mapping SourceColumn="Dr_Area" DataSetColumn="Dr_Area" />
              <Mapping SourceColumn="Agency" DataSetColumn="Agency" />
              <Mapping SourceColumn="Ref_ID" DataSetColumn="Ref_ID" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="Other" DataSetColumn="Other" />
              <Mapping SourceColumn="WaterBodyType" DataSetColumn="WaterBodyType" />
              <Mapping SourceColumn="Basin_Name" DataSetColumn="Basin_Name" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="County_Name" DataSetColumn="County_Name" />
              <Mapping SourceColumn="FIPS_Code" DataSetColumn="FIPS_Code" />
              <Mapping SourceColumn="EcoRegion" DataSetColumn="EcoRegion" />
              <Mapping SourceColumn="PlanRegion" DataSetColumn="PlanRegion" />
              <Mapping SourceColumn="Convert_Station_ID" DataSetColumn="Convert_Station_ID" />
              <Mapping SourceColumn="Create_Update" DataSetColumn="Create_Update" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PanamaDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PanamaDataSet" msprop:Generator_UserDSName="PanamaDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Pcodes" msprop:Generator_TableClassName="PcodesDataTable" msprop:Generator_TableVarName="tablePcodes" msprop:Generator_TablePropName="Pcodes" msprop:Generator_RowDeletingName="PcodesRowDeleting" msprop:Generator_RowChangingName="PcodesRowChanging" msprop:Generator_RowEvHandlerName="PcodesRowChangeEventHandler" msprop:Generator_RowDeletedName="PcodesRowDeleted" msprop:Generator_UserTableName="Pcodes" msprop:Generator_RowChangedName="PcodesRowChanged" msprop:Generator_RowEvArgName="PcodesRowChangeEvent" msprop:Generator_RowClassName="PcodesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PCode" msprop:Generator_ColumnVarNameInTable="columnPCode" msprop:Generator_ColumnPropNameInRow="PCode" msprop:Generator_ColumnPropNameInTable="PCodeColumn" msprop:Generator_UserColumnName="PCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Anal_Name" msprop:Generator_ColumnVarNameInTable="columnAnal_Name" msprop:Generator_ColumnPropNameInRow="Anal_Name" msprop:Generator_ColumnPropNameInTable="Anal_NameColumn" msprop:Generator_UserColumnName="Anal_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Units" msprop:Generator_ColumnVarNameInTable="columnUnits" msprop:Generator_ColumnPropNameInRow="Units" msprop:Generator_ColumnPropNameInTable="UnitsColumn" msprop:Generator_UserColumnName="Units" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Test_Method" msprop:Generator_ColumnVarNameInTable="columnTest_Method" msprop:Generator_ColumnPropNameInRow="Test_Method" msprop:Generator_ColumnPropNameInTable="Test_MethodColumn" msprop:Generator_UserColumnName="Test_Method" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Det_Limit" msprop:Generator_ColumnVarNameInTable="columnDet_Limit" msprop:Generator_ColumnPropNameInRow="Det_Limit" msprop:Generator_ColumnPropNameInTable="Det_LimitColumn" msprop:Generator_UserColumnName="Det_Limit" type="xs:double" minOccurs="0" />
              <xs:element name="Sig_Figs" msprop:Generator_ColumnVarNameInTable="columnSig_Figs" msprop:Generator_ColumnPropNameInRow="Sig_Figs" msprop:Generator_ColumnPropNameInTable="Sig_FigsColumn" msprop:Generator_UserColumnName="Sig_Figs" type="xs:double" minOccurs="0" />
              <xs:element name="Min_Limit" msprop:Generator_ColumnVarNameInTable="columnMin_Limit" msprop:Generator_ColumnPropNameInRow="Min_Limit" msprop:Generator_ColumnPropNameInTable="Min_LimitColumn" msprop:Generator_UserColumnName="Min_Limit" type="xs:double" minOccurs="0" />
              <xs:element name="Max_Limit" msprop:Generator_ColumnVarNameInTable="columnMax_Limit" msprop:Generator_ColumnPropNameInRow="Max_Limit" msprop:Generator_ColumnPropNameInTable="Max_LimitColumn" msprop:Generator_UserColumnName="Max_Limit" type="xs:double" minOccurs="0" />
              <xs:element name="Min_Criteria" msprop:Generator_ColumnVarNameInTable="columnMin_Criteria" msprop:Generator_ColumnPropNameInRow="Min_Criteria" msprop:Generator_ColumnPropNameInTable="Min_CriteriaColumn" msprop:Generator_UserColumnName="Min_Criteria" type="xs:double" minOccurs="0" />
              <xs:element name="Max_Criteria" msprop:Generator_ColumnVarNameInTable="columnMax_Criteria" msprop:Generator_ColumnPropNameInRow="Max_Criteria" msprop:Generator_ColumnPropNameInTable="Max_CriteriaColumn" msprop:Generator_UserColumnName="Max_Criteria" type="xs:double" minOccurs="0" />
              <xs:element name="Format_Str" msprop:Generator_ColumnVarNameInTable="columnFormat_Str" msprop:Generator_ColumnPropNameInRow="Format_Str" msprop:Generator_ColumnPropNameInTable="Format_StrColumn" msprop:Generator_UserColumnName="Format_Str" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Convert_PCode" msprop:Generator_ColumnVarNameInTable="columnConvert_PCode" msprop:Generator_ColumnPropNameInRow="Convert_PCode" msprop:Generator_ColumnPropNameInTable="Convert_PCodeColumn" msprop:Generator_UserColumnName="Convert_PCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Convert_Units" msprop:Generator_ColumnVarNameInTable="columnConvert_Units" msprop:Generator_ColumnPropNameInRow="Convert_Units" msprop:Generator_ColumnPropNameInTable="Convert_UnitsColumn" msprop:Generator_UserColumnName="Convert_Units" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Convert_Mult" msprop:Generator_ColumnVarNameInTable="columnConvert_Mult" msprop:Generator_ColumnPropNameInRow="Convert_Mult" msprop:Generator_ColumnPropNameInTable="Convert_MultColumn" msprop:Generator_UserColumnName="Convert_Mult" type="xs:double" minOccurs="0" />
              <xs:element name="WQX_CharacteristicName" msprop:Generator_ColumnVarNameInTable="columnWQX_CharacteristicName" msprop:Generator_ColumnPropNameInRow="WQX_CharacteristicName" msprop:Generator_ColumnPropNameInTable="WQX_CharacteristicNameColumn" msprop:Generator_UserColumnName="WQX_CharacteristicName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_ResultSampFraction" msprop:Generator_ColumnVarNameInTable="columnWQX_ResultSampFraction" msprop:Generator_ColumnPropNameInRow="WQX_ResultSampFraction" msprop:Generator_ColumnPropNameInTable="WQX_ResultSampFractionColumn" msprop:Generator_UserColumnName="WQX_ResultSampFraction" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_ResultMeasureUnit" msprop:Generator_ColumnVarNameInTable="columnWQX_ResultMeasureUnit" msprop:Generator_ColumnPropNameInRow="WQX_ResultMeasureUnit" msprop:Generator_ColumnPropNameInTable="WQX_ResultMeasureUnitColumn" msprop:Generator_UserColumnName="WQX_ResultMeasureUnit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_AnalyticalMethodIDContext" msprop:Generator_ColumnVarNameInTable="columnWQX_AnalyticalMethodIDContext" msprop:Generator_ColumnPropNameInRow="WQX_AnalyticalMethodIDContext" msprop:Generator_ColumnPropNameInTable="WQX_AnalyticalMethodIDContextColumn" msprop:Generator_UserColumnName="WQX_AnalyticalMethodIDContext" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_AnalyticalMethodID" msprop:Generator_ColumnVarNameInTable="columnWQX_AnalyticalMethodID" msprop:Generator_ColumnPropNameInRow="WQX_AnalyticalMethodID" msprop:Generator_ColumnPropNameInTable="WQX_AnalyticalMethodIDColumn" msprop:Generator_UserColumnName="WQX_AnalyticalMethodID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_AnalyticalMethodName" msprop:Generator_ColumnVarNameInTable="columnWQX_AnalyticalMethodName" msprop:Generator_ColumnPropNameInRow="WQX_AnalyticalMethodName" msprop:Generator_ColumnPropNameInTable="WQX_AnalyticalMethodNameColumn" msprop:Generator_UserColumnName="WQX_AnalyticalMethodName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_AnalyticalMethodQualifType" msprop:Generator_ColumnVarNameInTable="columnWQX_AnalyticalMethodQualifType" msprop:Generator_ColumnPropNameInRow="WQX_AnalyticalMethodQualifType" msprop:Generator_ColumnPropNameInTable="WQX_AnalyticalMethodQualifTypeColumn" msprop:Generator_UserColumnName="WQX_AnalyticalMethodQualifType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WQX_AnalyticalMethodDesc" msprop:Generator_ColumnVarNameInTable="columnWQX_AnalyticalMethodDesc" msprop:Generator_ColumnPropNameInRow="WQX_AnalyticalMethodDesc" msprop:Generator_ColumnPropNameInTable="WQX_AnalyticalMethodDescColumn" msprop:Generator_UserColumnName="WQX_AnalyticalMethodDesc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Create_Update" msprop:Generator_ColumnVarNameInTable="columnCreate_Update" msprop:Generator_ColumnPropNameInRow="Create_Update" msprop:Generator_ColumnPropNameInTable="Create_UpdateColumn" msprop:Generator_UserColumnName="Create_Update" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pvsca_Mtr" msprop:Generator_TableClassName="Pvsca_MtrDataTable" msprop:Generator_TableVarName="tablePvsca_Mtr" msprop:Generator_TablePropName="Pvsca_Mtr" msprop:Generator_RowDeletingName="Pvsca_MtrRowDeleting" msprop:Generator_RowChangingName="Pvsca_MtrRowChanging" msprop:Generator_RowEvHandlerName="Pvsca_MtrRowChangeEventHandler" msprop:Generator_RowDeletedName="Pvsca_MtrRowDeleted" msprop:Generator_UserTableName="Pvsca_Mtr" msprop:Generator_RowChangedName="Pvsca_MtrRowChanged" msprop:Generator_RowEvArgName="Pvsca_MtrRowChangeEvent" msprop:Generator_RowClassName="Pvsca_MtrRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RecID" msprop:Generator_ColumnVarNameInTable="columnRecID" msprop:Generator_ColumnPropNameInRow="RecID" msprop:Generator_ColumnPropNameInTable="RecIDColumn" msprop:Generator_UserColumnName="RecID" type="xs:int" />
              <xs:element name="Station_ID" msprop:Generator_ColumnVarNameInTable="columnStation_ID" msprop:Generator_ColumnPropNameInRow="Station_ID" msprop:Generator_ColumnPropNameInTable="Station_IDColumn" msprop:Generator_UserColumnName="Station_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date_Time" msprop:Generator_ColumnVarNameInTable="columnDate_Time" msprop:Generator_ColumnPropNameInRow="Date_Time" msprop:Generator_ColumnPropNameInTable="Date_TimeColumn" msprop:Generator_UserColumnName="Date_Time" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PCode" msprop:Generator_ColumnVarNameInTable="columnPCode" msprop:Generator_ColumnPropNameInRow="PCode" msprop:Generator_ColumnPropNameInTable="PCodeColumn" msprop:Generator_UserColumnName="PCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LEW_Pct" msprop:Generator_ColumnVarNameInTable="columnLEW_Pct" msprop:Generator_ColumnPropNameInRow="LEW_Pct" msprop:Generator_ColumnPropNameInTable="LEW_PctColumn" msprop:Generator_UserColumnName="LEW_Pct" type="xs:double" minOccurs="0" />
              <xs:element name="Depth_M" msprop:Generator_ColumnVarNameInTable="columnDepth_M" msprop:Generator_ColumnPropNameInRow="Depth_M" msprop:Generator_ColumnPropNameInTable="Depth_MColumn" msprop:Generator_UserColumnName="Depth_M" type="xs:double" minOccurs="0" />
              <xs:element name="Agency" msprop:Generator_ColumnVarNameInTable="columnAgency" msprop:Generator_ColumnPropNameInRow="Agency" msprop:Generator_ColumnPropNameInTable="AgencyColumn" msprop:Generator_UserColumnName="Agency" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CCode" msprop:Generator_ColumnVarNameInTable="columnCCode" msprop:Generator_ColumnPropNameInRow="CCode" msprop:Generator_ColumnPropNameInTable="CCodeColumn" msprop:Generator_UserColumnName="CCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LCode" msprop:Generator_ColumnVarNameInTable="columnLCode" msprop:Generator_ColumnPropNameInRow="LCode" msprop:Generator_ColumnPropNameInTable="LCodeColumn" msprop:Generator_UserColumnName="LCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SCode" msprop:Generator_ColumnVarNameInTable="columnSCode" msprop:Generator_ColumnPropNameInRow="SCode" msprop:Generator_ColumnPropNameInTable="SCodeColumn" msprop:Generator_UserColumnName="SCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QCode" msprop:Generator_ColumnVarNameInTable="columnQCode" msprop:Generator_ColumnPropNameInRow="QCode" msprop:Generator_ColumnPropNameInTable="QCodeColumn" msprop:Generator_UserColumnName="QCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RCode" msprop:Generator_ColumnVarNameInTable="columnRCode" msprop:Generator_ColumnPropNameInRow="RCode" msprop:Generator_ColumnPropNameInTable="RCodeColumn" msprop:Generator_UserColumnName="RCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Result" msprop:Generator_ColumnVarNameInTable="columnResult" msprop:Generator_ColumnPropNameInRow="Result" msprop:Generator_ColumnPropNameInTable="ResultColumn" msprop:Generator_UserColumnName="Result" type="xs:double" minOccurs="0" />
              <xs:element name="Validated" msprop:Generator_ColumnVarNameInTable="columnValidated" msprop:Generator_ColumnPropNameInRow="Validated" msprop:Generator_ColumnPropNameInTable="ValidatedColumn" msprop:Generator_UserColumnName="Validated" type="xs:boolean" minOccurs="0" />
              <xs:element name="Create_Update" msprop:Generator_ColumnVarNameInTable="columnCreate_Update" msprop:Generator_ColumnPropNameInRow="Create_Update" msprop:Generator_ColumnPropNameInTable="Create_UpdateColumn" msprop:Generator_UserColumnName="Create_Update" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Owner" msprop:Generator_ColumnVarNameInTable="columnOwner" msprop:Generator_ColumnPropNameInRow="Owner" msprop:Generator_ColumnPropNameInTable="OwnerColumn" msprop:Generator_UserColumnName="Owner" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Track_ID" msprop:Generator_ColumnVarNameInTable="columnTrack_ID" msprop:Generator_ColumnPropNameInRow="Track_ID" msprop:Generator_ColumnPropNameInTable="Track_IDColumn" msprop:Generator_UserColumnName="Track_ID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Stations" msprop:Generator_TableClassName="StationsDataTable" msprop:Generator_TableVarName="tableStations" msprop:Generator_TablePropName="Stations" msprop:Generator_RowDeletingName="StationsRowDeleting" msprop:Generator_RowChangingName="StationsRowChanging" msprop:Generator_RowEvHandlerName="StationsRowChangeEventHandler" msprop:Generator_RowDeletedName="StationsRowDeleted" msprop:Generator_UserTableName="Stations" msprop:Generator_RowChangedName="StationsRowChanged" msprop:Generator_RowEvArgName="StationsRowChangeEvent" msprop:Generator_RowClassName="StationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Station_ID" msprop:Generator_ColumnVarNameInTable="columnStation_ID" msprop:Generator_ColumnPropNameInRow="Station_ID" msprop:Generator_ColumnPropNameInTable="Station_IDColumn" msprop:Generator_UserColumnName="Station_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Station_Name" msprop:Generator_ColumnVarNameInTable="columnStation_Name" msprop:Generator_ColumnPropNameInRow="Station_Name" msprop:Generator_ColumnPropNameInTable="Station_NameColumn" msprop:Generator_UserColumnName="Station_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Station_Type" msprop:Generator_ColumnVarNameInTable="columnStation_Type" msprop:Generator_ColumnPropNameInRow="Station_Type" msprop:Generator_ColumnPropNameInTable="Station_TypeColumn" msprop:Generator_UserColumnName="Station_Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_Freq" msprop:Generator_ColumnVarNameInTable="columnData_Freq" msprop:Generator_ColumnPropNameInRow="Data_Freq" msprop:Generator_ColumnPropNameInTable="Data_FreqColumn" msprop:Generator_UserColumnName="Data_Freq" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" msprop:Generator_UserColumnName="Latitude" type="xs:double" minOccurs="0" />
              <xs:element name="Longitude" msprop:Generator_ColumnVarNameInTable="columnLongitude" msprop:Generator_ColumnPropNameInRow="Longitude" msprop:Generator_ColumnPropNameInTable="LongitudeColumn" msprop:Generator_UserColumnName="Longitude" type="xs:double" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" msprop:Generator_UserColumnName="Elevation" type="xs:double" minOccurs="0" />
              <xs:element name="HUC" msprop:Generator_ColumnVarNameInTable="columnHUC" msprop:Generator_ColumnPropNameInRow="HUC" msprop:Generator_ColumnPropNameInTable="HUCColumn" msprop:Generator_UserColumnName="HUC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Branch_ID" msprop:Generator_ColumnVarNameInTable="columnBranch_ID" msprop:Generator_ColumnPropNameInRow="Branch_ID" msprop:Generator_ColumnPropNameInTable="Branch_IDColumn" msprop:Generator_UserColumnName="Branch_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="River_Mile" msprop:Generator_ColumnVarNameInTable="columnRiver_Mile" msprop:Generator_ColumnPropNameInRow="River_Mile" msprop:Generator_ColumnPropNameInTable="River_MileColumn" msprop:Generator_UserColumnName="River_Mile" type="xs:double" minOccurs="0" />
              <xs:element name="Reach_ID" msprop:Generator_ColumnVarNameInTable="columnReach_ID" msprop:Generator_ColumnPropNameInRow="Reach_ID" msprop:Generator_ColumnPropNameInTable="Reach_IDColumn" msprop:Generator_UserColumnName="Reach_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dr_Area" msprop:Generator_ColumnVarNameInTable="columnDr_Area" msprop:Generator_ColumnPropNameInRow="Dr_Area" msprop:Generator_ColumnPropNameInTable="Dr_AreaColumn" msprop:Generator_UserColumnName="Dr_Area" type="xs:double" minOccurs="0" />
              <xs:element name="Agency" msprop:Generator_ColumnVarNameInTable="columnAgency" msprop:Generator_ColumnPropNameInRow="Agency" msprop:Generator_ColumnPropNameInTable="AgencyColumn" msprop:Generator_UserColumnName="Agency" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref_ID" msprop:Generator_ColumnVarNameInTable="columnRef_ID" msprop:Generator_ColumnPropNameInRow="Ref_ID" msprop:Generator_ColumnPropNameInTable="Ref_IDColumn" msprop:Generator_UserColumnName="Ref_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Other" msprop:Generator_ColumnVarNameInTable="columnOther" msprop:Generator_ColumnPropNameInRow="Other" msprop:Generator_ColumnPropNameInTable="OtherColumn" msprop:Generator_UserColumnName="Other" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WaterBodyType" msprop:Generator_ColumnVarNameInTable="columnWaterBodyType" msprop:Generator_ColumnPropNameInRow="WaterBodyType" msprop:Generator_ColumnPropNameInTable="WaterBodyTypeColumn" msprop:Generator_UserColumnName="WaterBodyType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Basin_Name" msprop:Generator_ColumnVarNameInTable="columnBasin_Name" msprop:Generator_ColumnPropNameInRow="Basin_Name" msprop:Generator_ColumnPropNameInTable="Basin_NameColumn" msprop:Generator_UserColumnName="Basin_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="County_Name" msprop:Generator_ColumnVarNameInTable="columnCounty_Name" msprop:Generator_ColumnPropNameInRow="County_Name" msprop:Generator_ColumnPropNameInTable="County_NameColumn" msprop:Generator_UserColumnName="County_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FIPS_Code" msprop:Generator_ColumnVarNameInTable="columnFIPS_Code" msprop:Generator_ColumnPropNameInRow="FIPS_Code" msprop:Generator_ColumnPropNameInTable="FIPS_CodeColumn" msprop:Generator_UserColumnName="FIPS_Code" type="xs:int" minOccurs="0" />
              <xs:element name="EcoRegion" msprop:Generator_ColumnVarNameInTable="columnEcoRegion" msprop:Generator_ColumnPropNameInRow="EcoRegion" msprop:Generator_ColumnPropNameInTable="EcoRegionColumn" msprop:Generator_UserColumnName="EcoRegion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PlanRegion" msprop:Generator_ColumnVarNameInTable="columnPlanRegion" msprop:Generator_ColumnPropNameInRow="PlanRegion" msprop:Generator_ColumnPropNameInTable="PlanRegionColumn" msprop:Generator_UserColumnName="PlanRegion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Convert_Station_ID" msprop:Generator_ColumnVarNameInTable="columnConvert_Station_ID" msprop:Generator_ColumnPropNameInRow="Convert_Station_ID" msprop:Generator_ColumnPropNameInTable="Convert_Station_IDColumn" msprop:Generator_UserColumnName="Convert_Station_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Create_Update" msprop:Generator_ColumnVarNameInTable="columnCreate_Update" msprop:Generator_ColumnPropNameInRow="Create_Update" msprop:Generator_ColumnPropNameInTable="Create_UpdateColumn" msprop:Generator_UserColumnName="Create_Update" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pcodes" />
      <xs:field xpath="mstns:PCode" />
    </xs:unique>
    <xs:unique name="Pvsca_Mtr_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pvsca_Mtr" />
      <xs:field xpath="mstns:RecID" />
    </xs:unique>
    <xs:unique name="Stations_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Stations" />
      <xs:field xpath="mstns:Station_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>